The Model Overview and BW
BW metadata appears in the Model Overview in the same manner as for any other system handled by ERP/CRM Integrator with one exception, and that is the usage of Table Type.
The Table Type in a ERP/CRM Integrator BW system describes the purpose of the table. The possible values are shown in the table below.
|
Table |
Description |
|---|---|
|
BW Fact (DB) |
Fact Table (Database) |
|
BW Fact Virt (DB) |
Fact Table for a Virtual-Provider (Database) |
|
BW Dim (DB) |
Dimension Table (Database) |
|
BW Charact.SID View (DB) |
A View table that acts as an intersection between a SID table and a Dimension (Database) |
|
BW Charact. SID (DB) |
Characteristic SID table (Database) |
|
BW Charact.Master Data (DB) |
Table defining the attributes of a Characteristic (Database) |
|
BW Charact.Master Data time dep.(DB) |
Table defining the attributes of a Time-dependent Characteristic (Database) |
|
BW Charact.Text (DB) |
Table defining the text attributes of a Characteristic (Database) |
|
BW Charact.SID time indep (DB)r |
Table defining a time-independent Characteristic (Database) |
|
BW Charact.SID time dep (DB)r |
Table defining a time-dependent Characteristic (Database) |
|
BW Charact. Hierarchy (DB) |
Table defining a Characteristic Hierarchy (Database) |
|
BW Charact. Hierarchy SID (DB) |
Table defining a Characteristic Hierarchy SID (Database) |
|
BW Charact. SID Hierarchy Struct (DB) |
Table defining a Characteristic SID Hierarchy Structure (Database) |
|
BW DSO (DB) |
A DSO table (Data Store Object) (Database) |
|
BW Cube |
A ‘virtual’ table that presents a Logical view of a BW Cube |
|
BW Cube Virt |
A ‘virtual’ table that presents a Logical view of a Virtual Provider |
|
BW Characteristic |
A ‘virtual’ table that presents a Logical view of a Characteristic |
|
BW DSO |
A ‘virtual’ table that represents a Logical view of a DSO |
|
BW Query |
A ‘virtual’ table that represents a BW Query |
|
BW InfoSource |
A 'virtual' table that represents a BW InfoSource |
|
BW DataSource |
A 'virtual' table that represents a BW DataSource |
|
BW Open Hub Destination |
A 'virtual' table that represents a BW Open Hub Destination |
|
BW Aggregation Level |
A 'virtual' table that represents a BW Aggregation Level |
In addition, for HANA-based SAP BW system:
|
Table |
Description |
|---|---|
| BW Adv. DSO | A 'virtual' table that represents a Logical view of an Advanced DSO |
| BW Composite Provider | A 'virtual' table that represents a HANA Composite Provider |
|
BW Open ODS View |
A 'virtual' table that represents an Open ODS View |
Using Advanced Search to select BW Table types
The Advanced Search feature ‘Standard filter’ tab (see Chapter: Browsing the metadata in ERP/CRM Integrator - for more details), has a Table Type dropdown list that, for a BW system, displays the possible Table Types listed in the table above.
The Table Type selection can be used in combination with any of the other search features to limit the range of tables displayed in the Model Overview.